Purpose of the Project

Yelp is becoming a growing platform for digital marketing. In our current day and age, having a effective digital presence on the internet can be vital to the success of a business. Through the Yelp Dataset, we hope to be able to discover insights that will help a new business be successful in their environment. For this project, we will be specifically focusing on the city of Las Vegas and the Yelp data involved. The source of our data is Yelp Data Set.

Summary Statistics

The total number of restaurants reviewed on Yelp for Las Vegas is 18153. 255628 people tipped in Las Vegas and North Las Vegas. The average star rating of the restaurants in Las Vegas and North Las Vegas is 3.6754531. The most reviewed restaurant was Mon Ami Gabi. The summary data for price range(Min, 1st Quartile, Median, Mean, 3rd Quartile, Max, NA’s) is 1, 1, 2, 1.8098836, 2, 4, 6902.

Summary Table by Rating

The following summary table groups the data by star ratings and calculates the total number of checkins, tips and reviews. The star rating is arranged in ascending order. By arranging the data in this way we can know the summary about the various star-ratings.

Rating Checkins Tips Reviews
1.0 1272 145 1397
1.5 12513 1373 8134
2.0 46172 4052 16332
2.5 188141 13528 53994
3.0 511429 33775 122801
3.5 1025875 72697 241564
4.0 1197592 87745 323649
4.5 476721 36549 152025
5.0 63995 5764 39800

The most number of checkins, tips, and reviews were at restaurants with rating 4.0. This means people reviews on Yelp mostly if they find the place is worth a 4.0 rating.

Map of Las Vegas Businesses

This map of Las Vegas shows the star rating of every single business on Yelp. The color designates the star rating for the business. It is intended to allow a user to zoom into a specific are and see if it is concentrated with a specific star rating. In the future, we will be attempting to create a shiny UI that allows users to see where there are 1-star, 2-star, 3-star, 4-star, and 5-star businesses. In a broad scope, the map shows that a majority of businesses in Las Vegas regardless of region is rated 4-star and 5-star

Map of Businesses with over 1000 Reviews

This map of Las Vegas is filtered by businesses with over 1000 reviews in Las Vegas. The total number of businesses with over 1000 reviews is 104 businesses. When a user clicks on a point, they will get information such as the name, number of check-ins, and the average star rating of the restaurant. We hope that this will give the user an idea of what the top businesses in Las Vegas according to Yelp would be. We chose the map so that users can see the vicinity or area with the top businesses.

Bar Chart of Price Ranges in Las Vegas

Above is a bar chart of the different price levels for businesses in the Las Vegas region. We included this to show prospective business owners on what the most common price level is for businesses in the area. This bar graph demonstrates that a majority of restaurants were in the $11-$30 range.

Scatter Plot of Check-Ins Versus Reviews

We wanted to find the correlation of people that were checking into the business and see if they were also leaving a review. We found that a majority of the people that checked in did not end up leaving a review. We wanted to include this to allow prospective businesses to see if running check-in promotions would increase the amount of positive reviews on their Yelp profile.